SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_inscripcionespolimodal2
AS
SELECT    Organizacion, Turno, Carrera, COUNT(*) AS cantidad, AbanderadoEscolta, TieneHermanos
FROM         dbo.vw_inscriptosPolimodal
WHERE     (AnioLectivo = 2009) --AND (cargo LIKE '%miranda%')
--WHERE     (AnioLectivo = 2015) 
GROUP BY Organizacion, Turno, Carrera, AbanderadoEscolta, TieneHermanos




GO
